﻿CREATE TABLE [dbo].[ContainerAdmission] (
    [Id]                INT           IDENTITY (1, 1) NOT NULL,
    [IsDeleted]         BIT           NOT NULL,
    [CreatedDate]       DATETIME      NOT NULL,
    [ModifiedDate]      DATETIME      NOT NULL,
    [TaskId]            INT           NOT NULL,
    [ContainerNumber]   VARCHAR (32)  NOT NULL,
    [BillNumber]        VARCHAR (32)  NULL,
    [Conveyance]        VARCHAR (32)  NULL,
    [VoyageNumber]      VARCHAR (16)  NULL,
    [DeclarationNumber] VARCHAR (32)  NULL,
    [AdmissionDate]     DATETIME      NULL,
    [AdmissionStatus]   NVARCHAR (32) NULL,
    [DockReceipt]       NVARCHAR (32) NULL,
    [SequenceNumber]    VARCHAR (16)  NULL,
    [WarningMessage]    NVARCHAR (64) NULL
);

